05. Video: JOINs with Comparison Operators

Joining without an Equals Sign

Inequality JOINs

Expert Tip

If you recall from earlier lessons on joins, the join clause is evaluated before the where clause -- filtering in the join clause will eliminate rows before they are joined, while filtering in the WHERE clause will leave those rows in and produce some nulls.